using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class web_pages_ajax_san_ntd_ds_cho_pv : System.Web.UI.Page
{
    public DataTable resdtt;
    public string ma_san = "";
    public string ma_ntd = "";
    NguoiTimViecCommon NTVComm = new NguoiTimViecCommon();
    NhaTuyenDungCommon NTDComm = new NhaTuyenDungCommon();
    Common comm = new Common();
    public SanGDVL sanComm = new SanGDVL();
    protected void Page_Load(object sender, EventArgs e)
    {
        ma_ntd = NTDComm.getMaNTD(Session["SanNTDuser"].ToString());
        ma_san = Request.QueryString["sid"];
        string sql = "select * from SanGiaoDich_nop_ho_so " +
                     " inner join  (select NguoiTimViec_ho_so.ma_ho_so,chuc_danh_mong_muon,tieu_de,ho_ten,NguoiTimViec_ho_so.ma_nguoi from NguoiTimViec_ho_so inner join Connguoi_nguoi on NguoiTimViec_ho_so.ma_nguoi = Connguoi_nguoi.ma_nguoi ) " +
                     " as A on a.ma_nguoi = ma_ntv  where ma_san ='" + ma_san + "' and duyet = 1 " +
                     " and  ma_vlt in (select ma_ho_so_tuyen_dung from SanGiaoDich_doanh_nghiep where ma_san = '" + ma_san + "' and ma_doanh_nghiep = '" + ma_ntd + "')";


        resdtt = comm.getDataTable(sql);
    }
}
